package com.example.managesystem.mapper;


import org.apache.ibatis.annotations.*;

@Mapper
public interface MidItemFailureMapper {
    /**
     * 中期项目未通过原因
     * @param itemId
     * @param failReason
     */
    @Insert("insert into midterm_failure(item_id,failure_text) values(#{itemId},#{failReason})")
    void insertFailure(@Param("itemId") Integer itemId, @Param("failReason") String failReason);



    /**
     * 进展记录未通过原因
     * @param itemId
     * @param failReason
     */
 

    /**
     * 查看项目中期失败原因
     * @param itemId
     *
     */
    @Select("select failure_text from midterm_failure where item_id = #{itemId}")
    String LookFailureReason(Integer itemId);
}
